USE [{0}]
SELECT 
	IDCol.TABLE_NAME AS [TABLE_NAME],
	IDCol.TABLE_SCHEMA AS [TABLE_SCHEMA],
	IDCol.[COLUMN_NAME] AS [COLUMN_NAME], 
	IDCol.[COLUMN_DEFAULT] AS [COLUMN_DEFAULT],
	CASE WHEN IDCol.[IS_NULLABLE]='YES' THEN 1 WHEN IDCol.[IS_NULLABLE]='NO' THEN 0 END AS [IS_NULLABLE], 
	IDCol.[DATA_TYPE] AS [DATA_TYPE], 
	IDCol.[CHARACTER_MAXIMUM_LENGTH] AS [CHARACTER_MAXIMUM_LENGTH],
	CASE WHEN [COLUMN_NAME] = (
		SELECT
			ID.[name]
		FROM  sys.tables TPK
			INNER JOIN sys.identity_columns ID
				ON ID.object_id = TPK.object_id
		WHERE TPK.[name] = '{1}') THEN 1 ELSE 0 END AS [AUTO_INCREMENT]
FROM INFORMATION_SCHEMA.COLUMNS IDCol
WHERE [TABLE_NAME]='{1}'